Mass recoding

• Reference (field REFCDF)

Recoding reference. It is a freely selected alphanumerical code.
Each reference deals with one single table.

• Description (field REFDES)

Recoding description.

• Process status (field PROSTA)

When creating the reference, only the status: To process or To process (Intra-group sale) can be selected.
At the end of the processing, the status is automatically changed into: Processed or Processed (Intra-group sale).

• Table name (field TABNAM)

In creation mode, this field is used to enter the name of the table for which recoding some codes or of all the codes is required.
This can be:
- one of the miscellaneous tables of the Fixed assets or Expenses modules,
- one of the analytical dimensions table,
- theLocation table: LOC orGeographic sites: FCY, only if the recoding concerns an intra-group transfer.
Once the reference of the recoding created, the table can no longer be modified.

• Table name (field TABNAMDES)

This non modifiable field displays the description of the table that is affected by the recoding.

• Process date (field PRODAT)

This field, that cannot be modified, is automatically loaded with the date at which the recoding processing is carried out.

• Intra-grp trans ref (field REFTRFCMP)

This field can be viewed only if the status of the processing is set to: To process (Intra-group transfer) or Processed (Intra-group transfer).

• If it is a recoding: To process (Intra-group transfer), the reference of an existing transfer must be entered.
• If it is a recoding: Processed (Intra-group transfer), this reference cannot be modified.

• Operation description (field DESTRFCMP)

Title of the intra-group sale. Non-modifiable field.

• Dimension type code (field CCEDIE)

This field is used only when the recoding concerns an analytical dimension type. The entry of the dimension type code is mandatory.

• User (field PROUSR)

This non modifiable field displays the name of the user that has launched the processing.

• Prev code status (field STAOLDCOD)

This field can only be entered when the status of the processing is set toTo process.
It is used to specify if the former codes must be kept are deleted.
When the setup is designed to an intra-group transfer, the former codes must be kept, this field cannot be modified then.
In the case of an analytical dimensions table recoding:
-  It is also possible to assign the Inactive status to the former codes, in which case, it is necessary to enter a validity end date in the following field.
- Assign the Inactive or Deleted statuses to the former codes is only possible if the analytical dimensions table is not shared. If it is shared, the status automatically takes the Kept value.

• Validity end date (field DATENDACT)

This field is displayed and can be entered only if the processing status is: To be processed, and if the recoding concerns the analytical dimensions table with the Previous status codes positioned at: Inactive
It is used to specify the date from which a record carrying the code to recodify, will not be modifiable if it keeps its original value.

• Associations update (field FLGUPDASS)

This flag is activated to specify that an association will be recoded if one of its elements has been recoded (determining and/or determined value).
It is automatically activated and cannot be modified as soon as the Former codes status has for value: Deleted.
As soon as the processing status has for value: Processed, it can no longer be modified.
It automatically deactivated and cannot be modified when the recoding concerns an intra-group transfer.

• Simulation (field FLGSIM)

This check box is selected by default and runs the closing in simulation mode. In this case, controls and the process are carried out but there are no updates recorded in the database.

Clear this check box to run in actual mode. In this case, you cannot reverse the closing and updates are recorded in the database. If you are using intermediate commits, it is recommended that the NIVTRACE – Log file level parameter (AAS chapter, MIS group) value is 0.

• Log : print of updates (field FLGTRCEDT)

This flag is used, when activated, to edit, in the log file, the details of the updates.
This flag cannot be entered:
- As soon as the processing status has for value: Processed.
- When the recoding concerns an intra-group transfer (the Log file option will be selected in the Intra-group transfer processing).

• Before(code) (field VALOLDCOD)

This column displays the list of table lines to recodify.
If the recoding concerns the FCY sites table:
- Only the geographical sites are suggested.
- Right-clicking on Site location Recod. on a line is used to display a window that authorizes the the site locations recoding.

• Before (label) (field VALOLDDES)

Title of the table line. This information cannot be modified.

• After (code) (field VALNEWCOD)

This column is used to enter the value of the new code, as long as the status of the processing has not been set to Processed or Processed (intra-group transfer).

• When the recoding concerns a miscellaneous table or a non-shared analytical dimension table (CCE), the value of the new code will update, during the recoding processing, the target objects (Assets, Expenses ...) and will also create the codes of the processed table if this value does not exist.
   
• When the recoding concerns the FCY sites table, the value of the new code will update the target objects (Assets, Expenses, ...) during the recoding processing on the LOC location table or on a shared analytical dimension table (CCE). However, it will not update the processed table, the codes must have been created in the table beforehand.

• After (label) (field VALNEWDES)

This column cannot be modified if the status of the processing has been set to Processed or Processed (intra-group transfer).

• When the recoding concerns a miscellaneous table and a non-shared analytical dimensions (CCE), this field is used to enter the title corresponding to the new code which will be inserted in the table. This field is loaded by default with the original title.
  
• When the recoding concerns the FCY site table or a shared analytical dimension table (CCE), this field cannot be modified ; it displays the title corresponding to the code entered which must have been created in the table beforehand.
   When the recoding concerns a location table (LOC), this column is replaced by the one entitled After (Location).

• Master object (field OBCLDR)

The master object is the object on which the recoding is mainly carried out. This setup is applied when the status of the former codes has for value: Stored or Inactive.

• When the status of the former codes is set on: Deleted, this field is empty and cannot be modified: all the objects must be processed and none of them can be a master object.
  
• When the recoding is designed to an intra-group sale, the master object must be the Fixed asset.

 The Physical count lists and Physical assetsobjects cannot be master objects.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.

• Assets (field OBCPCDFAS)

This checkbox is used to specify that the recoding of the Fixed assets object is required.
When the master object is the Fixed asset, this box must be activated.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.

• Expenses (field OBCPCDLOF)

This checkbox is used to specify that the recoding of the Expenses object is required.
When the master object is the Expense, this box must be activated.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.

• Funding contracts (field OBCPCDLEA)

This checkbox is used to specify that the recoding of the Financial contracts object is required.
When the master object is the Lease contract, this box must be activated.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.

• Subsidies (field OBCPCDGRT)

This checkbox is used to specify that the recoding of the Subsidies object is required.
When the master object is the Subsidy, this box must be activated.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodings function.

• Physical assets (field OBCPCDPHY)

This checkbox is used to specify that the recoding of the Physical assets object is required.
When the status of the former codes is set on: Deleted, all the objects must be processed; they are all checked and cannot be modified.
The selection terms of the different object recordings depend on the choice of the master object. These terms are described in the help of the Mass recodingsfunction.

• field FLGCPY

The activation of this box is used to select the company on which the processing must be carried out.
After selecting a company, all the financial sites that are assigned to it are selected by default.
A click right option is used to select/deselect all the companies or financial sites attached to the companies.

• When the recoding is intended to an intra-group transfer, the selection of the companies/sites is forbidden as it is carried out at the level of the transfer setup.
• When the statuses of the former codes are the following: Deleted, all the companies are systematically selected and cannot be deactivated.
• When the statuses of the former codes are the following: Kept or Inactive and when the status is: To be processed, the selection of at least one company is mandatory.

• Company (field CPY)

This field displays the company code.

• field FLGFCY

This checkbox is activated for the site to be taken into account in the processing. After selecting a company, all the financial sites that are linked to it are selected by default.
A click right option is used to select/deselect all the companies or financial sites attached to the companies.

• When the recoding is intended to an intra-group transfer, the selection of the companies/sites is forbidden as it is carried out at the level of the transfer setup.
• When the statuses of the former codes are the following: Deleted, all the companies are systematically selected and cannot be deactivated.
• When the statuses of the former codes are the following: Kept or Inactive and when the status is: To be processed, the selection of at least one company is mandatory.

• Company (field FCYCPY)

Identification Code for the company which the site is linked to.

• Site (field FCY)

This field cannot be modified and displays the code of the site on which the process is carried out.

• Object (field OBJNAM)

• Description (field OBJDES)

• Table (field TBL1)

Indicate a table amongst the principal object table and the linked tables.

• Field (field FLD1)

Indicate a field from the table.

• Operator (field OPE1)

Indicate the comparison operation:

• The "indifferent" operator is used to obtain all records of an object.
• The '* ?' operator is used to define wildcards.

• Value (field VAL1)

This field is used to indicate the comparison value (without quotation marks for the alphabetic fields).

• And/or (field ANDOR2)

Indicate the link between the criteria lines.

For instance:
If you enter Expr1 and Expr2 or Expr3, then you get (Expr1 & (Expr2 | (Expr3)))

• Table (field TBL2)

• Field (field FLD2)

• Operator (field OPE2)

• Value (field VAL2)

• And/or (field ANDOR3)

• Table (field TBL3)

• Field (field FLD3)

• Operator (field OPE3)

• Value (field VAL3)

• And/or (field ANDOR4)

• Table (field TBL4)

• Field (field FLD4)

• Operator (field OPE4)

• Value (field VAL4)

• And/or (field ANDOR5)

• Table (field TBL5)

• Field (field FLD5)

• Operator (field OPE5)

• Value (field VAL5)

• field REQUETE